package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * 使用预编译SQL完成UPDATE操作
 */
public class JDBCDemo10 {
    public static void main(String[] args) {
        //需求:根据客户id修改用户的密码,昵称,年龄
      try (Connection connection =DBUtil.getConnection();){
      String sql= "UPDATE userinfo " +
               "SET password=?,nickname=?,age=? " +
              "where id=? ";
          PreparedStatement ps=connection.prepareStatement(sql);
          ps.setString(1,"999999");
          ps.setString(2,"大奇");
          ps.setInt(3,33);
          ps.setInt(4,2);
          int num=ps.executeUpdate();
          System.out.println(num>0?"修改成功":"修改失败");

      } catch (SQLException ex) {
          throw new RuntimeException(ex);
      }


      }
    }

